BEGIN;
CREATE TABLE t1(n int, log int);
CREATE TABLE t2 AS SELECT DISTINCT log FROM t1 UNION ALL SELECT n FROM t1 WHERE log=3 ORDER BY log;
CREATE TABLE t3(a text, b float, c text);
INSERT INTO t3 VALUES(1, 1.1, '1.1');
INSERT INTO t3 VALUES(2, 1.10, '1.10');
INSERT INTO t3 VALUES(3, 1.10, '1.1');
INSERT INTO t3 VALUES(4, 1.1, '1.10');
INSERT INTO t3 VALUES(5, 1.2, '1.2');
INSERT INTO t3 VALUES(6, 1.3, '1.3');
COMMIT;
SELECT x, y FROM t2 UNION SELECT a, b FROM t3 ORDER BY x LIMIT 1;
SELECT 0 AS x, 1 AS y UNION SELECT 2 AS p, 3 AS q UNION SELECT 4 AS a, 5 AS b ORDER BY x LIMIT 1;
SELECT * FROM (SELECT 123), (SELECT 456) ON likely(0 OR 1) OR 0;
VALUES(1),(2),(3) EXCEPT VALUES(1),(3);
VALUES(1),(2),(3),(4) UNION ALL SELECT 5 LIMIT 3;
